By selecting Create Crosstab Report from the Survey menu (or by pressing ⌘-R), you will be able to create an analysis report of the survey based on the response choices of any one of the survey’s questions. You will be prompted to select a number from a popup menu that represents the question you want to act as the basis for the overall analysis.
After selecting a question number, a dialog box will offer a group of options for the report’s output.
• If you want only a portion of the survey questions analyzed by the selected question’s responses, you can choose to analyze a series of questions that are in consecutive order by entering inclusive starting and ending numbers. To analyze only one question use the same number for both ends of the series.
• Up to four tables can be created for each question analyzed: one that counts the number of responses for all possible response choices (including NAs), one that calculates the percentage of responses by columns, another that calculates the percentage of responses by rows, and one more that calculates the percentage of responses overall. You can direct MacSurvey to create all four tables, or only the count table. A set of radio buttons offers the option. The pre-selected button is Only Count Tables.
• You also have the option to include the text of questions and response choices above their respective tables. A set of radio buttons offers the option. The pre-selected button is No text.
• Another option allows you to tell MacSurvey whether to include any responses in the NA row in the totals that are used when the percentage values are calculated. A set of radio buttons offers the option. The pre-selected button is No NAs in the percentage calculations.
After selecting the options, you must name the report. To aid in identifying the many reports that you might create when analyzing the survey, filenames should be patterned after the question number or the text of the question used as a basis for the report. For example, a report based on the first question could be named Q1 or something similar. If you try to name a report with a filename that already exists in the folder where you want to save the report, MacSurvey will offer a dialog box asking if you want to replace the existing file.
After naming the report, the Macintosh will begin “thinking” about the questionnaires. After the Macintosh starts thinking, you can stop the data analysis by clicking Cancel. Any part of the report that had been created before canceling the analysis will be saved to the file.
The sample report shows what Question #1 of a hypothetical questionnaire would look like in a crosstab report that had been analyzed based on Question #3 (which had two response choices). The column headings for the report represent the response choices to Question #3. In the example the options selected were: include all data tables; not to include text of questions and responses; and not to include responses in the NA row in percentage calculations. If Question #3 had asked the respondents to indicate their sex and choice A was male, then 13 males and 11 females responded to the survey.
Question 1 results tabulated by Question 3’s choices
Q3A Q3B Q3N TOTAL
========================
A 6 5 0 11
B 3 2 0 5
C 2 3 0 5
D 1 1 0 2
NA 1 0 0 1
========================
13 11 0 24
COMPLETE RESPONSES = 23
RESPONSE RATE = 95.8%
Mean = 1.91 (NA row factored out)
Mean = 2.04 (NA row factored in)
Question 1 (NA row not factored into percentages)
Results by columns based on Question 3’s choices
Q3A Q3B Q3N TOTAL
========================
A 50.0 45.5 0.0 47.8
B 25.0 18.2 0.0 21.7
C 16.7 27.3 0.0 21.7
D 8.3 9.1 0.0 8.7
========================
100.0 100.0 0.0 100.0
Question 1 (NA row not factored into percentages)
Results by row based on Question 3’s choices
Q3A Q3B Q3N TOTAL
========================
A 54.5 45.5 0.0 100.0
B 60.0 40.0 0.0 100.0
C 40.0 60.0 0.0 100.0
D 50.0 50.0 0.0 100.0
========================
52.2 47.8 0.0 100.0
Question 1 (NA row not factored into percentages)
Results overall based on Question 3’s choices
Q3A Q3B Q3N TOTAL
========================
A 26.1 21.7 0.0 47.8
B 13.0 8.7 0.0 21.7
C 8.7 13.0 0.0 21.7
D 4.3 4.3 0.0 8.7
========================
52.2 47.8 0.0 100.0
All reports can be viewed or printed from within MacSurvey by selecting the appropriate File menu command. If a report is larger than 32 kilobytes MacSurvey will not display the entire report.
All reports are saved as plain text files so that a word processing or desktop publishing program can be used, if desired, to polish reports. If a report is saved in a format other than plain text, MacSurvey will no longer be able to display or print the report. When editing any MacSurvey report, a monospace font similar to Monaco or Courier should be used to maintain proper alignment of numerical totals and column headings.
